File_SettingRead

Reads setting from config file Config file can be passed as argument ...

NextID_Reset

Checks if ID has been reset in SQL database table If yes, it will reset it and ...

DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...

DB_Connect_Install.zip

IntlIsAlphaCharacter

Test if a character is alphanumeric, regardless of the code page or language ...

Reset ID Column

How to reset ID Column in Microsoft SQL, (not completed yet). This is because ...

GeneratePostID

Two functions to generate ID that is unique (not found in database) ...

AN_SafeFileName

Clean filename from special characters to make it safe for server upload Then ...

MinOfArray

Gets the id of an item with minimum in an array of numbers, with option

Copy formulas

How to copy formulas in VBA code. Learned that the hard way, just like most of ...

LastInsertedID_SQL

Get the ID of the last inserted record in a table. There are other methods, ...

Excel 2010 hyperlink issue fix

An issue I started to see when clicking on a hyperlink in Excel 2010, while I ...

Hyperlink-Excel-Fix.zip

Save to, Read from, Delete registry key

Save into registry, read from registry or delete a key. Accessible to only ...